Pandas Profiling Report

Dataset statistics

Number of variables	23
Number of observations	4325
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.1 MiB
Average record size in memory	758.0 B

Variable types

Categorical	10
Numeric	13

Alerts

`Date` has a high cardinality: 1278 distinct values	High cardinality
`Production Date` has a high cardinality: 1405 distinct values	High cardinality
`Expiration Date` has a high cardinality: 1441 distinct values	High cardinality
`Product ID` is highly overall correlated with `Product Name` and 1 other fields	High correlation
`Quantity (liters/kg)` is highly overall correlated with `Total Value` and 3 other fields	High correlation
`Price per Unit` is highly overall correlated with `Total Value` and 1 other fields	High correlation
`Total Value` is highly overall correlated with `Quantity (liters/kg)` and 5 other fields	High correlation
`Shelf Life (days)` is highly overall correlated with `Product Name` and 1 other fields	High correlation
`Quantity Sold (liters/kg)` is highly overall correlated with `Quantity (liters/kg)` and 2 other fields	High correlation
`Price per Unit (sold)` is highly overall correlated with `Price per Unit` and 1 other fields	High correlation
`Approx. Total Revenue(INR)` is highly overall correlated with `Quantity (liters/kg)` and 2 other fields	High correlation
`Quantity in Stock (liters/kg)` is highly overall correlated with `Quantity (liters/kg)` and 1 other fields	High correlation
`Product Name` is highly overall correlated with `Product ID` and 2 other fields	High correlation
`Storage Condition` is highly overall correlated with `Product ID` and 2 other fields	High correlation
`Date` is uniformly distributed	Uniform
`Production Date` is uniformly distributed	Uniform
`Expiration Date` is uniformly distributed	Uniform

Reproduction

Analysis started	2023-09-05 12:52:52.033480
Analysis finished	2023-09-05 12:53:42.923387
Duration	50.89 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

Location
Categorical

Distinct	15
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	278.2 KiB

Delhi	525
Chandigarh	519
Uttar Pradesh	276
Gujarat	267
Karnataka	261
Other values (10)	2477

Length

Max length	14
Median length	11
Mean length	8.830289
Min length	5

Characters and Unicode

Total characters	38191
Distinct characters	31
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Telangana
2nd row	Uttar Pradesh
3rd row	Tamil Nadu
4th row	Telangana
5th row	Maharashtra

Common Values

Value	Count	Frequency (%)
Delhi	525	12.1%
Chandigarh	519	12.0%
Uttar Pradesh	276	6.4%
Gujarat	267	6.2%
Karnataka	261	6.0%
Madhya Pradesh	259	6.0%
Rajasthan	256	5.9%
Maharashtra	255	5.9%
Haryana	253	5.8%
Kerala	249	5.8%
Other values (5)	1205	27.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pradesh	535	10.0%
delhi	525	9.9%
chandigarh	519	9.7%
uttar	276	5.2%
gujarat	267	5.0%
karnataka	261	4.9%
madhya	259	4.9%
rajasthan	256	4.8%
maharashtra	255	4.8%
haryana	253	4.8%
Other values (8)	1918	36.0%

Most occurring characters

Value	Count	Frequency (%)
a	9162	24.0%
h	3864	10.1%
r	3363	8.8%
n	2274	6.0%
e	2039	5.3%
t	1832	4.8%
d	1784	4.7%
i	1512	4.0%
l	1486	3.9%
s	1287	3.4%
Other values (21)	9588	25.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	31868	83.4%
Uppercase Letter	5324	13.9%
Space Separator	999	2.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	9162	28.7%
h	3864	12.1%
r	3363	10.6%
n	2274	7.1%
e	2039	6.4%
t	1832	5.7%
d	1784	5.6%
i	1512	4.7%
l	1486	4.7%
s	1287	4.0%
Other values (6)	3265	10.2%

Uppercase Letter

Value	Count	Frequency (%)
P	535	10.0%
D	525	9.9%
C	519	9.7%
M	514	9.7%
K	510	9.6%
B	486	9.1%
T	471	8.8%
U	276	5.2%
G	267	5.0%
R	256	4.8%
Other values (4)	965	18.1%

Space Separator

Value	Count	Frequency (%)
	999	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	37192	97.4%
Common	999	2.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	9162	24.6%
h	3864	10.4%
r	3363	9.0%
n	2274	6.1%
e	2039	5.5%
t	1832	4.9%
d	1784	4.8%
i	1512	4.1%
l	1486	4.0%
s	1287	3.5%
Other values (20)	8589	23.1%

Common

Value	Count	Frequency (%)
	999	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	38191	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	9162	24.0%
h	3864	10.1%
r	3363	8.8%
n	2274	6.0%
e	2039	5.3%
t	1832	4.8%
d	1784	4.7%
i	1512	4.0%
l	1486	3.9%
s	1287	3.4%
Other values (21)	9588	25.1%

Total Land Area (acres)
Real number (ℝ)

Distinct	4235
Distinct (%)	97.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	503.48307

Minimum	10.17
Maximum	999.53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	10.17
5-th percentile	56.362
Q1	252.95
median	509.17
Q3	751.25
95-th percentile	946.298
Maximum	999.53
Range	989.36
Interquartile range (IQR)	498.3

Descriptive statistics

Standard deviation	285.93506
Coefficient of variation (CV)	0.56791395
Kurtosis	-1.2038243
Mean	503.48307
Median Absolute Deviation (MAD)	249.55
Skewness	-0.020572007
Sum	2177564.3
Variance	81758.859
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
609.62	3	0.1%
637.96	2	< 0.1%
50.61	2	< 0.1%
207.06	2	< 0.1%
783.52	2	< 0.1%
131.86	2	< 0.1%
378.37	2	< 0.1%
837.07	2	< 0.1%
50.03	2	< 0.1%
680.4	2	< 0.1%
Other values (4225)	4304	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10.17	1	< 0.1%
10.25	1	< 0.1%
10.32	1	< 0.1%
10.91	1	< 0.1%
11.32	1	< 0.1%
11.48	2	< 0.1%
11.73	1	< 0.1%
11.86	1	< 0.1%
12	1	< 0.1%
12.64	1	< 0.1%

Value	Count	Frequency (%)
999.53	1	< 0.1%
999.39	1	< 0.1%
999.18	1	< 0.1%
998.99	1	< 0.1%
998.55	1	< 0.1%
998.53	1	< 0.1%
998.5	1	< 0.1%
998.12	1	< 0.1%
997.31	1	< 0.1%
997.26	1	< 0.1%

Number of Cows
Real number (ℝ)

Distinct	91
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.963699

Minimum	10
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	10
5-th percentile	14
Q1	32
median	55
Q3	77
95-th percentile	96
Maximum	100
Range	90
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	26.111487
Coefficient of variation (CV)	0.47506785
Kurtosis	-1.1917445
Mean	54.963699
Median Absolute Deviation (MAD)	23
Skewness	0.019617027
Sum	237718
Variance	681.80974
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
89	63	1.5%
25	63	1.5%
34	62	1.4%
55	61	1.4%
94	60	1.4%
29	60	1.4%
58	60	1.4%
42	59	1.4%
77	59	1.4%
28	58	1.3%
Other values (81)	3720	86.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	45	1.0%
11	47	1.1%
12	47	1.1%
13	50	1.2%
14	41	0.9%
15	34	0.8%
16	45	1.0%
17	44	1.0%
18	45	1.0%
19	50	1.2%

Value	Count	Frequency (%)
100	44	1.0%
99	40	0.9%
98	54	1.2%
97	42	1.0%
96	51	1.2%
95	48	1.1%
94	60	1.4%
93	46	1.1%
92	50	1.2%
91	46	1.1%

Farm Size
Categorical

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	263.4 KiB

Large	1462
Medium	1439
Small	1424

Length

Max length	6
Median length	5
Mean length	5.3327168
Min length	5

Characters and Unicode

Total characters	23064
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Medium
2nd row	Large
3rd row	Medium
4th row	Small
5th row	Medium

Common Values

Value	Count	Frequency (%)
Large	1462	33.8%
Medium	1439	33.3%
Small	1424	32.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
large	1462	33.8%
medium	1439	33.3%
small	1424	32.9%

Most occurring characters

Value	Count	Frequency (%)
e	2901	12.6%
a	2886	12.5%
m	2863	12.4%
l	2848	12.3%
L	1462	6.3%
r	1462	6.3%
g	1462	6.3%
M	1439	6.2%
d	1439	6.2%
i	1439	6.2%
Other values (2)	2863	12.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	18739	81.2%
Uppercase Letter	4325	18.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2901	15.5%
a	2886	15.4%
m	2863	15.3%
l	2848	15.2%
r	1462	7.8%
g	1462	7.8%
d	1439	7.7%
i	1439	7.7%
u	1439	7.7%

Uppercase Letter

Value	Count	Frequency (%)
L	1462	33.8%
M	1439	33.3%
S	1424	32.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	23064	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	2901	12.6%
a	2886	12.5%
m	2863	12.4%
l	2848	12.3%
L	1462	6.3%
r	1462	6.3%
g	1462	6.3%
M	1439	6.2%
d	1439	6.2%
i	1439	6.2%
Other values (2)	2863	12.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	23064	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	2901	12.6%
a	2886	12.5%
m	2863	12.4%
l	2848	12.3%
L	1462	6.3%
r	1462	6.3%
g	1462	6.3%
M	1439	6.2%
d	1439	6.2%
i	1439	6.2%
Other values (2)	2863	12.4%

Date
Categorical

HIGH CARDINALITY UNIFORM

Distinct	1278
Distinct (%)	29.5%
Missing	0
Missing (%)	0.0%
Memory size	283.1 KiB

28/01/2021	11
22/09/2022	10
20/04/2020	9
23/06/2019	9
21/09/2021	9
Other values (1273)	4277

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	43250
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	161 ?
Unique (%)	3.7%

Sample

1st row	17/02/2022
2nd row	01/12/2021
3rd row	28/02/2022
4th row	09/06/2019
5th row	14/12/2020

Common Values

Value	Count	Frequency (%)
28/01/2021	11	0.3%
22/09/2022	10	0.2%
20/04/2020	9	0.2%
23/06/2019	9	0.2%
21/09/2021	9	0.2%
23/11/2022	9	0.2%
03/10/2021	8	0.2%
19/10/2020	8	0.2%
15/07/2021	8	0.2%
01/04/2020	8	0.2%
Other values (1268)	4236	97.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
28/01/2021	11	0.3%
22/09/2022	10	0.2%
20/04/2020	9	0.2%
23/06/2019	9	0.2%
21/09/2021	9	0.2%
23/11/2022	9	0.2%
20/01/2020	8	0.2%
05/06/2021	8	0.2%
10/12/2021	8	0.2%
20/09/2019	8	0.2%
Other values (1268)	4236	97.9%

Most occurring characters

Value	Count	Frequency (%)
2	11145	25.8%
0	10725	24.8%
/	8650	20.0%
1	6025	13.9%
9	1786	4.1%
6	877	2.0%
7	842	1.9%
5	837	1.9%
3	806	1.9%
4	792	1.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	34600	80.0%
Other Punctuation	8650	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	11145	32.2%
0	10725	31.0%
1	6025	17.4%
9	1786	5.2%
6	877	2.5%
7	842	2.4%
5	837	2.4%
3	806	2.3%
4	792	2.3%
8	765	2.2%

Other Punctuation

Value	Count	Frequency (%)
/	8650	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	43250	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	11145	25.8%
0	10725	24.8%
/	8650	20.0%
1	6025	13.9%
9	1786	4.1%
6	877	2.0%
7	842	1.9%
5	837	1.9%
3	806	1.9%
4	792	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43250	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	11145	25.8%
0	10725	24.8%
/	8650	20.0%
1	6025	13.9%
9	1786	4.1%
6	877	2.0%
7	842	1.9%
5	837	1.9%
3	806	1.9%
4	792	1.8%

Product ID
Real number (ℝ)

Distinct	10
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.5095954

Minimum	1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	8
95-th percentile	10
Maximum	10
Range	9
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.8429787
Coefficient of variation (CV)	0.516005
Kurtosis	-1.1980782
Mean	5.5095954
Median Absolute Deviation (MAD)	2
Skewness	-0.024827298
Sum	23829
Variance	8.0825282
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
6	479	11.1%
7	447	10.3%
9	441	10.2%
4	437	10.1%
8	435	10.1%
2	431	10.0%
1	429	9.9%
5	423	9.8%
10	402	9.3%
3	401	9.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	429	9.9%
2	431	10.0%
3	401	9.3%
4	437	10.1%
5	423	9.8%
6	479	11.1%
7	447	10.3%
8	435	10.1%
9	441	10.2%
10	402	9.3%

Value	Count	Frequency (%)
10	402	9.3%
9	441	10.2%
8	435	10.1%
7	447	10.3%
6	479	11.1%
5	423	9.8%
4	437	10.1%
3	401	9.3%
2	431	10.0%
1	429	9.9%

Product Name
Categorical

Distinct	10
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	266.2 KiB

Curd	479
Lassi	447
Paneer	441
Yogurt	437
Buttermilk	435
Other values (5)	2086

Length

Max length	10
Median length	9
Mean length	5.9865896
Min length	4

Characters and Unicode

Total characters	25892
Distinct characters	25
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Ice Cream
2nd row	Milk
3rd row	Yogurt
4th row	Cheese
5th row	Buttermilk

Common Values

Value	Count	Frequency (%)
Curd	479	11.1%
Lassi	447	10.3%
Paneer	441	10.2%
Yogurt	437	10.1%
Buttermilk	435	10.1%
Butter	431	10.0%
Milk	429	9.9%
Ice Cream	423	9.8%
Ghee	402	9.3%
Cheese	401	9.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
curd	479	10.1%
lassi	447	9.4%
paneer	441	9.3%
yogurt	437	9.2%
buttermilk	435	9.2%
butter	431	9.1%
milk	429	9.0%
ice	423	8.9%
cream	423	8.9%
ghee	402	8.5%

Most occurring characters

Value	Count	Frequency (%)
e	4601	17.8%
r	2646	10.2%
t	2169	8.4%
u	1782	6.9%
a	1311	5.1%
i	1311	5.1%
C	1303	5.0%
s	1295	5.0%
B	866	3.3%
k	864	3.3%
Other values (15)	7744	29.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	20721	80.0%
Uppercase Letter	4748	18.3%
Space Separator	423	1.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	4601	22.2%
r	2646	12.8%
t	2169	10.5%
u	1782	8.6%
a	1311	6.3%
i	1311	6.3%
s	1295	6.2%
k	864	4.2%
l	864	4.2%
m	858	4.1%
Other values (6)	3020	14.6%

Uppercase Letter

Value	Count	Frequency (%)
C	1303	27.4%
B	866	18.2%
L	447	9.4%
P	441	9.3%
Y	437	9.2%
M	429	9.0%
I	423	8.9%
G	402	8.5%

Space Separator

Value	Count	Frequency (%)
	423	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	25469	98.4%
Common	423	1.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	4601	18.1%
r	2646	10.4%
t	2169	8.5%
u	1782	7.0%
a	1311	5.1%
i	1311	5.1%
C	1303	5.1%
s	1295	5.1%
B	866	3.4%
k	864	3.4%
Other values (14)	7321	28.7%

Common

Value	Count	Frequency (%)
	423	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25892	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	4601	17.8%
r	2646	10.2%
t	2169	8.4%
u	1782	6.9%
a	1311	5.1%
i	1311	5.1%
C	1303	5.0%
s	1295	5.0%
B	866	3.3%
k	864	3.3%
Other values (15)	7744	29.9%

Brand
Categorical

Distinct	11
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	273.6 KiB

Amul	1053
Mother Dairy	1010
Raj	685
Sudha	648
Dodla Dairy	222
Other values (6)	707

Length

Max length	20
Median length	16
Mean length	7.7574566
Min length	3

Characters and Unicode

Total characters	33551
Distinct characters	32
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Dodla Dairy
2nd row	Amul
3rd row	Dodla Dairy
4th row	Britannia Industries
5th row	Mother Dairy

Common Values

Value	Count	Frequency (%)
Amul	1053	24.3%
Mother Dairy	1010	23.4%
Raj	685	15.8%
Sudha	648	15.0%
Dodla Dairy	222	5.1%
Palle2patnam	211	4.9%
Dynamix Dairies	106	2.5%
Warana	104	2.4%
Parag Milk Foods	102	2.4%
Passion Cheese	96	2.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
dairy	1232	20.4%
amul	1053	17.4%
mother	1010	16.7%
raj	685	11.3%
sudha	648	10.7%
dodla	222	3.7%
palle2patnam	211	3.5%
dairies	106	1.8%
dynamix	106	1.8%
warana	104	1.7%
Other values (7)	674	11.1%

Most occurring characters

Value	Count	Frequency (%)
a	4420	13.2%
r	2730	8.1%
i	2012	6.0%
l	1799	5.4%
u	1789	5.3%
h	1754	5.2%
	1726	5.1%
e	1703	5.1%
D	1666	5.0%
o	1532	4.6%
Other values (22)	12420	37.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	25563	76.2%
Uppercase Letter	6051	18.0%
Space Separator	1726	5.1%
Decimal Number	211	0.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	4420	17.3%
r	2730	10.7%
i	2012	7.9%
l	1799	7.0%
u	1789	7.0%
h	1754	6.9%
e	1703	6.7%
o	1532	6.0%
t	1397	5.5%
m	1370	5.4%
Other values (9)	5057	19.8%

Uppercase Letter

Value	Count	Frequency (%)
D	1666	27.5%
M	1112	18.4%
A	1053	17.4%
R	685	11.3%
S	648	10.7%
P	409	6.8%
W	104	1.7%
F	102	1.7%
C	96	1.6%
B	88	1.5%

Space Separator

Value	Count	Frequency (%)
	1726	100.0%

Decimal Number

Value	Count	Frequency (%)
2	211	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	31614	94.2%
Common	1937	5.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	4420	14.0%
r	2730	8.6%
i	2012	6.4%
l	1799	5.7%
u	1789	5.7%
h	1754	5.5%
e	1703	5.4%
D	1666	5.3%
o	1532	4.8%
t	1397	4.4%
Other values (20)	10812	34.2%

Common

Value	Count	Frequency (%)
	1726	89.1%
2	211	10.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	33551	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	4420	13.2%
r	2730	8.1%
i	2012	6.0%
l	1799	5.4%
u	1789	5.3%
h	1754	5.2%
	1726	5.1%
e	1703	5.1%
D	1666	5.0%
o	1532	4.6%
Other values (22)	12420	37.0%

Quantity (liters/kg)
Real number (ℝ)

Distinct	4224
Distinct (%)	97.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	500.65266

Minimum	1.17
Maximum	999.93
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	1.17
5-th percentile	45.516
Q1	254.17
median	497.55
Q3	749.78
95-th percentile	946.194
Maximum	999.93
Range	998.76
Interquartile range (IQR)	495.61

Descriptive statistics

Standard deviation	288.97592
Coefficient of variation (CV)	0.57719841
Kurtosis	-1.1912202
Mean	500.65266
Median Absolute Deviation (MAD)	247.63
Skewness	-0.014905626
Sum	2165322.7
Variance	83507.08
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
318.52	3	0.1%
34.5	3	0.1%
385.32	2	< 0.1%
423.1	2	< 0.1%
68.79	2	< 0.1%
339.45	2	< 0.1%
965.9	2	< 0.1%
485.65	2	< 0.1%
345.37	2	< 0.1%
432.96	2	< 0.1%
Other values (4214)	4303	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.17	1	< 0.1%
1.22	1	< 0.1%
1.24	1	< 0.1%
1.58	1	< 0.1%
2.11	1	< 0.1%
2.29	1	< 0.1%
2.72	1	< 0.1%
3.1	1	< 0.1%
3.23	1	< 0.1%
3.46	1	< 0.1%

Value	Count	Frequency (%)
999.93	1	< 0.1%
999.87	1	< 0.1%
999.82	1	< 0.1%
999.8	1	< 0.1%
999.78	1	< 0.1%
999.16	1	< 0.1%
998.55	1	< 0.1%
998.52	1	< 0.1%
997.98	1	< 0.1%
997.91	1	< 0.1%

Price per Unit
Real number (ℝ)

Distinct	3409
Distinct (%)	78.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.785938

Minimum	10.03
Maximum	99.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	10.03
5-th percentile	14.056
Q1	32.46
median	54.4
Q3	77.46
95-th percentile	95.198
Maximum	99.99
Range	89.96
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	26.002815
Coefficient of variation (CV)	0.47462571
Kurtosis	-1.197723
Mean	54.785938
Median Absolute Deviation (MAD)	22.39
Skewness	0.0093223587
Sum	236949.18
Variance	676.14638
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
85.72	5	0.1%
94.88	4	0.1%
46.01	4	0.1%
29.74	4	0.1%
31.05	4	0.1%
58.57	4	0.1%
24.45	4	0.1%
41.05	4	0.1%
22.47	4	0.1%
66.12	4	0.1%
Other values (3399)	4284	99.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10.03	1	< 0.1%
10.05	1	< 0.1%
10.09	1	< 0.1%
10.11	2	< 0.1%
10.15	1	< 0.1%
10.16	2	< 0.1%
10.17	1	< 0.1%
10.19	1	< 0.1%
10.28	1	< 0.1%
10.32	1	< 0.1%

Value	Count	Frequency (%)
99.99	1	< 0.1%
99.96	2	< 0.1%
99.94	1	< 0.1%
99.84	1	< 0.1%
99.78	2	< 0.1%
99.73	1	< 0.1%
99.71	1	< 0.1%
99.7	1	< 0.1%
99.68	1	< 0.1%
99.65	1	< 0.1%

Total Value
Real number (ℝ)

Distinct	4324
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27357.845

Minimum	42.5165
Maximum	99036.37
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	42.5165
5-th percentile	1843.367
Q1	9946.8145
median	21869.653
Q3	40954.441
95-th percentile	70700.452
Maximum	99036.37
Range	98993.853
Interquartile range (IQR)	31007.626

Descriptive statistics

Standard deviation	21621.052
Coefficient of variation (CV)	0.79030535
Kurtosis	0.014246727
Mean	27357.845
Median Absolute Deviation (MAD)	14194.94
Skewness	0.87398539
Sum	1.1832268 × 10⁸
Variance	4.6746987 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15929.8755	2	< 0.1%
19064.128	1	< 0.1%
14688.26	1	< 0.1%
17256.0762	1	< 0.1%
10514.3223	1	< 0.1%
16689.9376	1	< 0.1%
34924.3664	1	< 0.1%
8040.2208	1	< 0.1%
60949.6079	1	< 0.1%
1064.272	1	< 0.1%
Other values (4314)	4314	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
42.5165	1	< 0.1%
46.0428	1	< 0.1%
47.43	1	< 0.1%
59.2722	1	< 0.1%
70.6056	1	< 0.1%
73.2962	1	< 0.1%
93.67	1	< 0.1%
97.5096	1	< 0.1%
106.32	1	< 0.1%
114.4176	1	< 0.1%

Value	Count	Frequency (%)
99036.3696	1	< 0.1%
97631.1921	1	< 0.1%
96528.5579	1	< 0.1%
96137.34	1	< 0.1%
94594.4951	1	< 0.1%
94246.0402	1	< 0.1%
94083.759	1	< 0.1%
93714.673	1	< 0.1%
93567.2472	1	< 0.1%
93254.265	1	< 0.1%

Shelf Life (days)
Real number (ℝ)

Distinct	146
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.12763

Minimum	1
Maximum	150
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	10
median	22
Q3	30
95-th percentile	101
Maximum	150
Range	149
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	30.272114
Coefficient of variation (CV)	1.0392921
Kurtosis	4.1148805
Mean	29.12763
Median Absolute Deviation (MAD)	11
Skewness	2.0824962
Sum	125977
Variance	916.40091
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7	264	6.1%
13	196	4.5%
12	177	4.1%
14	174	4.0%
6	159	3.7%
26	158	3.7%
5	154	3.6%
28	150	3.5%
29	137	3.2%
30	131	3.0%
Other values (136)	2625	60.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	119	2.8%
2	106	2.5%
5	154	3.6%
6	159	3.7%
7	264	6.1%
8	105	2.4%
9	101	2.3%
10	111	2.6%
11	117	2.7%
12	177	4.1%

Value	Count	Frequency (%)
150	5	0.1%
149	3	0.1%
148	8	0.2%
147	7	0.2%
146	6	0.1%
145	5	0.1%
144	5	0.1%
143	6	0.1%
142	2	< 0.1%
141	3	0.1%

Storage Condition
Categorical

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	284.0 KiB

Refrigerated	2459
Frozen	1035
Ambient	402
Polythene Packet	225
Tetra Pack	204

Length

Max length	16
Median length	12
Mean length	10.213179
Min length	6

Characters and Unicode

Total characters	44172
Distinct characters	24
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Frozen
2nd row	Tetra Pack
3rd row	Refrigerated
4th row	Frozen
5th row	Refrigerated

Common Values

Value	Count	Frequency (%)
Refrigerated	2459	56.9%
Frozen	1035	23.9%
Ambient	402	9.3%
Polythene Packet	225	5.2%
Tetra Pack	204	4.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
refrigerated	2459	51.7%
frozen	1035	21.8%
ambient	402	8.5%
polythene	225	4.7%
packet	225	4.7%
tetra	204	4.3%
pack	204	4.3%

Most occurring characters

Value	Count	Frequency (%)
e	9693	21.9%
r	6157	13.9%
t	3515	8.0%
a	3092	7.0%
i	2861	6.5%
R	2459	5.6%
f	2459	5.6%
g	2459	5.6%
d	2459	5.6%
n	1662	3.8%
Other values (14)	7356	16.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	38989	88.3%
Uppercase Letter	4754	10.8%
Space Separator	429	1.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	9693	24.9%
r	6157	15.8%
t	3515	9.0%
a	3092	7.9%
i	2861	7.3%
f	2459	6.3%
g	2459	6.3%
d	2459	6.3%
n	1662	4.3%
o	1260	3.2%
Other values (8)	3372	8.6%

Uppercase Letter

Value	Count	Frequency (%)
R	2459	51.7%
F	1035	21.8%
P	654	13.8%
A	402	8.5%
T	204	4.3%

Space Separator

Value	Count	Frequency (%)
	429	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	43743	99.0%
Common	429	1.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	9693	22.2%
r	6157	14.1%
t	3515	8.0%
a	3092	7.1%
i	2861	6.5%
R	2459	5.6%
f	2459	5.6%
g	2459	5.6%
d	2459	5.6%
n	1662	3.8%
Other values (13)	6927	15.8%

Common

Value	Count	Frequency (%)
	429	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	44172	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	9693	21.9%
r	6157	13.9%
t	3515	8.0%
a	3092	7.0%
i	2861	6.5%
R	2459	5.6%
f	2459	5.6%
g	2459	5.6%
d	2459	5.6%
n	1662	3.8%
Other values (14)	7356	16.7%

Production Date
Categorical

HIGH CARDINALITY UNIFORM

Distinct	1405
Distinct (%)	32.5%
Missing	0
Missing (%)	0.0%
Memory size	283.1 KiB

13/01/2022	9
03/09/2019	9
06/09/2022	9
09/11/2021	9
11/07/2019	8
Other values (1400)	4281

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	43250
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	240 ?
Unique (%)	5.5%

Sample

1st row	27/12/2021
2nd row	03/10/2021
3rd row	14/01/2022
4th row	15/05/2019
5th row	17/10/2020

Common Values

Value	Count	Frequency (%)
13/01/2022	9	0.2%
03/09/2019	9	0.2%
06/09/2022	9	0.2%
09/11/2021	9	0.2%
11/07/2019	8	0.2%
18/01/2021	8	0.2%
22/05/2019	8	0.2%
30/12/2021	8	0.2%
12/07/2020	8	0.2%
06/11/2019	8	0.2%
Other values (1395)	4241	98.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
13/01/2022	9	0.2%
06/09/2022	9	0.2%
09/11/2021	9	0.2%
03/09/2019	9	0.2%
12/07/2020	8	0.2%
06/09/2021	8	0.2%
10/11/2022	8	0.2%
06/11/2019	8	0.2%
03/09/2020	8	0.2%
30/12/2021	8	0.2%
Other values (1395)	4241	98.1%

Most occurring characters

Value	Count	Frequency (%)
2	10986	25.4%
0	10759	24.9%
/	8650	20.0%
1	5999	13.9%
9	1879	4.3%
3	992	2.3%
8	889	2.1%
7	795	1.8%
6	773	1.8%
5	772	1.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	34600	80.0%
Other Punctuation	8650	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	10986	31.8%
0	10759	31.1%
1	5999	17.3%
9	1879	5.4%
3	992	2.9%
8	889	2.6%
7	795	2.3%
6	773	2.2%
5	772	2.2%
4	756	2.2%

Other Punctuation

Value	Count	Frequency (%)
/	8650	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	43250	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	10986	25.4%
0	10759	24.9%
/	8650	20.0%
1	5999	13.9%
9	1879	4.3%
3	992	2.3%
8	889	2.1%
7	795	1.8%
6	773	1.8%
5	772	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43250	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	10986	25.4%
0	10759	24.9%
/	8650	20.0%
1	5999	13.9%
9	1879	4.3%
3	992	2.3%
8	889	2.1%
7	795	1.8%
6	773	1.8%
5	772	1.8%

Expiration Date
Categorical

HIGH CARDINALITY UNIFORM

Distinct	1441
Distinct (%)	33.3%
Missing	0
Missing (%)	0.0%
Memory size	283.1 KiB

27/07/2019	9
15/01/2021	9
01/02/2022	9
04/03/2020	9
10/03/2021	8
Other values (1436)	4281

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	43250
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	273 ?
Unique (%)	6.3%

Sample

1st row	21/01/2022
2nd row	25/10/2021
3rd row	13/02/2022
4th row	26/07/2019
5th row	28/10/2020

Common Values

Value	Count	Frequency (%)
27/07/2019	9	0.2%
15/01/2021	9	0.2%
01/02/2022	9	0.2%
04/03/2020	9	0.2%
10/03/2021	8	0.2%
09/01/2019	8	0.2%
19/04/2020	8	0.2%
18/01/2021	8	0.2%
03/08/2019	8	0.2%
26/08/2019	8	0.2%
Other values (1431)	4241	98.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
27/07/2019	9	0.2%
01/02/2022	9	0.2%
04/03/2020	9	0.2%
15/01/2021	9	0.2%
06/02/2022	8	0.2%
04/02/2019	8	0.2%
01/03/2020	8	0.2%
19/05/2021	8	0.2%
10/04/2019	8	0.2%
15/08/2019	8	0.2%
Other values (1431)	4241	98.1%

Most occurring characters

Value	Count	Frequency (%)
2	11034	25.5%
0	10781	24.9%
/	8650	20.0%
1	5964	13.8%
9	1819	4.2%
3	1043	2.4%
8	820	1.9%
5	819	1.9%
6	796	1.8%
4	767	1.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	34600	80.0%
Other Punctuation	8650	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	11034	31.9%
0	10781	31.2%
1	5964	17.2%
9	1819	5.3%
3	1043	3.0%
8	820	2.4%
5	819	2.4%
6	796	2.3%
4	767	2.2%
7	757	2.2%

Other Punctuation

Value	Count	Frequency (%)
/	8650	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	43250	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	11034	25.5%
0	10781	24.9%
/	8650	20.0%
1	5964	13.8%
9	1819	4.2%
3	1043	2.4%
8	820	1.9%
5	819	1.9%
6	796	1.8%
4	767	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43250	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	11034	25.5%
0	10781	24.9%
/	8650	20.0%
1	5964	13.8%
9	1819	4.2%
3	1043	2.4%
8	820	1.9%
5	819	1.9%
6	796	1.8%
4	767	1.8%

Quantity Sold (liters/kg)
Real number (ℝ)

Distinct	806
Distinct (%)	18.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	248.09503

Minimum	1
Maximum	960
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	1
5-th percentile	8.2
Q1	69
median	189
Q3	374
95-th percentile	678
Maximum	960
Range	959
Interquartile range (IQR)	305

Descriptive statistics

Standard deviation	217.02418
Coefficient of variation (CV)	0.87476231
Kurtosis	0.25000228
Mean	248.09503
Median Absolute Deviation (MAD)	138
Skewness	0.98198255
Sum	1073011
Variance	47099.495
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	41	0.9%
2	37	0.9%
8	27	0.6%
9	26	0.6%
4	25	0.6%
5	25	0.6%
13	24	0.6%
6	22	0.5%
48	22	0.5%
7	22	0.5%
Other values (796)	4054	93.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	41	0.9%
2	37	0.9%
3	18	0.4%
4	25	0.6%
5	25	0.6%
6	22	0.5%
7	22	0.5%
8	27	0.6%
9	26	0.6%
10	20	0.5%

Value	Count	Frequency (%)
960	1	< 0.1%
956	1	< 0.1%
949	3	0.1%
945	1	< 0.1%
940	1	< 0.1%
934	1	< 0.1%
931	1	< 0.1%
930	2	< 0.1%
928	1	< 0.1%
926	1	< 0.1%

Price per Unit (sold)
Real number (ℝ)

Distinct	3446
Distinct (%)	79.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.77914

Minimum	5.21
Maximum	104.51
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	5.21
5-th percentile	14.216
Q1	32.64
median	54.14
Q3	77.46
95-th percentile	95.336
Maximum	104.51
Range	99.3
Interquartile range (IQR)	44.82

Descriptive statistics

Standard deviation	26.19279
Coefficient of variation (CV)	0.47815264
Kurtosis	-1.1578943
Mean	54.77914
Median Absolute Deviation (MAD)	22.26
Skewness	0.014238974
Sum	236919.78
Variance	686.06227
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.3	6	0.1%
73.22	5	0.1%
40.1	5	0.1%
27.5	4	0.1%
25.47	4	0.1%
15.52	4	0.1%
32.97	4	0.1%
45.86	4	0.1%
17.74	4	0.1%
49.08	4	0.1%
Other values (3436)	4281	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5.21	1	< 0.1%
5.61	2	< 0.1%
5.94	2	< 0.1%
6.12	1	< 0.1%
6.58	1	< 0.1%
6.77	1	< 0.1%
6.78	1	< 0.1%
6.87	1	< 0.1%
6.95	1	< 0.1%
7.11	1	< 0.1%

Value	Count	Frequency (%)
104.51	1	< 0.1%
104.15	1	< 0.1%
104.06	1	< 0.1%
103.89	1	< 0.1%
103.61	1	< 0.1%
103.57	1	< 0.1%
103.49	1	< 0.1%
103.2	1	< 0.1%
103.19	1	< 0.1%
103.11	1	< 0.1%

Approx. Total Revenue(INR)
Real number (ℝ)

Distinct	4304
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13580.265

Minimum	12.54
Maximum	89108.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	12.54
5-th percentile	342.796
Q1	2916.65
median	8394.54
Q3	19504.55
95-th percentile	44801.764
Maximum	89108.9
Range	89096.36
Interquartile range (IQR)	16587.9

Descriptive statistics

Standard deviation	14617.009
Coefficient of variation (CV)	1.0763419
Kurtosis	3.0207264
Mean	13580.265
Median Absolute Deviation (MAD)	6621.9
Skewness	1.6916456
Sum	58734648
Variance	2.1365696 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2646.6	2	< 0.1%
6096	2	< 0.1%
18895.8	2	< 0.1%
4010.4	2	< 0.1%
3906	2	< 0.1%
8053.5	2	< 0.1%
7081.02	2	< 0.1%
5004	2	< 0.1%
129.78	2	< 0.1%
4875.12	2	< 0.1%
Other values (4294)	4305	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12.54	1	< 0.1%
14.99	1	< 0.1%
16.3	1	< 0.1%
17.46	1	< 0.1%
19.66	1	< 0.1%
20.45	1	< 0.1%
21.12	1	< 0.1%
22.29	1	< 0.1%
23.89	1	< 0.1%
24.02	1	< 0.1%

Value	Count	Frequency (%)
89108.9	1	< 0.1%
85913.52	1	< 0.1%
85352.94	1	< 0.1%
85036.41	1	< 0.1%
84838.46	1	< 0.1%
83934.9	1	< 0.1%
81350.52	1	< 0.1%
80237	1	< 0.1%
78360.4	1	< 0.1%
78214.5	1	< 0.1%

Customer Location
Categorical

Distinct	15
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	278.1 KiB

Delhi	499
Chandigarh	489
Bihar	284
Maharashtra	271
Kerala	267
Other values (10)	2515

Length

Max length	14
Median length	11
Mean length	8.825896
Min length	5

Characters and Unicode

Total characters	38172
Distinct characters	31
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Madhya Pradesh
2nd row	Kerala
3rd row	Madhya Pradesh
4th row	Rajasthan
5th row	Jharkhand

Common Values

Value	Count	Frequency (%)
Delhi	499	11.5%
Chandigarh	489	11.3%
Bihar	284	6.6%
Maharashtra	271	6.3%
Kerala	267	6.2%
Tamil Nadu	267	6.2%
Uttar Pradesh	267	6.2%
Karnataka	264	6.1%
West Bengal	264	6.1%
Telangana	251	5.8%
Other values (5)	1202	27.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pradesh	515	9.6%
delhi	499	9.3%
chandigarh	489	9.1%
bihar	284	5.3%
maharashtra	271	5.0%
kerala	267	5.0%
tamil	267	5.0%
nadu	267	5.0%
uttar	267	5.0%
bengal	264	4.9%
Other values (8)	1981	36.9%

Most occurring characters

Value	Count	Frequency (%)
a	9136	23.9%
h	3786	9.9%
r	3348	8.8%
n	2225	5.8%
e	2060	5.4%
t	1815	4.8%
d	1762	4.6%
l	1548	4.1%
i	1539	4.0%
s	1284	3.4%
Other values (21)	9669	25.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	31755	83.2%
Uppercase Letter	5371	14.1%
Space Separator	1046	2.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	9136	28.8%
h	3786	11.9%
r	3348	10.5%
n	2225	7.0%
e	2060	6.5%
t	1815	5.7%
d	1762	5.5%
l	1548	4.9%
i	1539	4.8%
s	1284	4.0%
Other values (6)	3252	10.2%

Uppercase Letter

Value	Count	Frequency (%)
B	548	10.2%
K	531	9.9%
M	519	9.7%
T	518	9.6%
P	515	9.6%
D	499	9.3%
C	489	9.1%
N	267	5.0%
U	267	5.0%
W	264	4.9%
Other values (4)	954	17.8%

Space Separator

Value	Count	Frequency (%)
	1046	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	37126	97.3%
Common	1046	2.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	9136	24.6%
h	3786	10.2%
r	3348	9.0%
n	2225	6.0%
e	2060	5.5%
t	1815	4.9%
d	1762	4.7%
l	1548	4.2%
i	1539	4.1%
s	1284	3.5%
Other values (20)	8623	23.2%

Common

Value	Count	Frequency (%)
	1046	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	38172	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	9136	23.9%
h	3786	9.9%
r	3348	8.8%
n	2225	5.8%
e	2060	5.4%
t	1815	4.8%
d	1762	4.6%
l	1548	4.1%
i	1539	4.0%
s	1284	3.4%
Other values (21)	9669	25.3%

Sales Channel
Categorical

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	270.5 KiB

Retail	1478
Wholesale	1476
Online	1371

Length

Max length	9
Median length	6
Mean length	7.023815
Min length	6

Characters and Unicode

Total characters	30378
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Wholesale
2nd row	Wholesale
3rd row	Online
4th row	Online
5th row	Retail

Common Values

Value	Count	Frequency (%)
Retail	1478	34.2%
Wholesale	1476	34.1%
Online	1371	31.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
retail	1478	34.2%
wholesale	1476	34.1%
online	1371	31.7%

Most occurring characters

Value	Count	Frequency (%)
e	5801	19.1%
l	5801	19.1%
a	2954	9.7%
i	2849	9.4%
n	2742	9.0%
R	1478	4.9%
t	1478	4.9%
W	1476	4.9%
h	1476	4.9%
o	1476	4.9%
Other values (2)	2847	9.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	26053	85.8%
Uppercase Letter	4325	14.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	5801	22.3%
l	5801	22.3%
a	2954	11.3%
i	2849	10.9%
n	2742	10.5%
t	1478	5.7%
h	1476	5.7%
o	1476	5.7%
s	1476	5.7%

Uppercase Letter

Value	Count	Frequency (%)
R	1478	34.2%
W	1476	34.1%
O	1371	31.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	30378	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	5801	19.1%
l	5801	19.1%
a	2954	9.7%
i	2849	9.4%
n	2742	9.0%
R	1478	4.9%
t	1478	4.9%
W	1476	4.9%
h	1476	4.9%
o	1476	4.9%
Other values (2)	2847	9.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	30378	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	5801	19.1%
l	5801	19.1%
a	2954	9.7%
i	2849	9.4%
n	2742	9.0%
R	1478	4.9%
t	1478	4.9%
W	1476	4.9%
h	1476	4.9%
o	1476	4.9%
Other values (2)	2847	9.4%

Quantity in Stock (liters/kg)
Real number (ℝ)

Distinct	808
Distinct (%)	18.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	252.06867

Minimum	0
Maximum	976
Zeros	18
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	0
5-th percentile	8
Q1	66
median	191
Q3	387
95-th percentile	714
Maximum	976
Range	976
Interquartile range (IQR)	321

Descriptive statistics

Standard deviation	223.62087
Coefficient of variation (CV)	0.88714266
Kurtosis	0.11768276
Mean	252.06867
Median Absolute Deviation (MAD)	145
Skewness	0.96230075
Sum	1090197
Variance	50006.293
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	33	0.8%
8	33	0.8%
1	32	0.7%
7	31	0.7%
10	30	0.7%
21	26	0.6%
4	24	0.6%
5	23	0.5%
9	22	0.5%
14	22	0.5%
Other values (798)	4049	93.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	18	0.4%
1	32	0.7%
2	33	0.8%
3	14	0.3%
4	24	0.6%
5	23	0.5%
6	16	0.4%
7	31	0.7%
8	33	0.8%
9	22	0.5%

Value	Count	Frequency (%)
976	1	< 0.1%
968	1	< 0.1%
962	1	< 0.1%
955	1	< 0.1%
948	3	0.1%
945	1	< 0.1%
944	1	< 0.1%
941	1	< 0.1%
932	1	< 0.1%
930	1	< 0.1%

Minimum Stock Threshold (liters/kg)
Real number (ℝ)

Distinct	3432
Distinct (%)	79.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	55.826143

Minimum	10.02
Maximum	99.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	10.02
5-th percentile	14.804
Q1	32.91
median	56.46
Q3	79.01
95-th percentile	95.734
Maximum	99.99
Range	89.97
Interquartile range (IQR)	46.1

Descriptive statistics

Standard deviation	26.30145
Coefficient of variation (CV)	0.47113141
Kurtosis	-1.2333583
Mean	55.826143
Median Absolute Deviation (MAD)	23.11
Skewness	-0.041864116
Sum	241448.07
Variance	691.76626
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20.28	4	0.1%
96.27	4	0.1%
45.63	4	0.1%
57.39	4	0.1%
11.63	4	0.1%
29.73	4	0.1%
40.89	4	0.1%
53.4	4	0.1%
83.01	4	0.1%
94.08	4	0.1%
Other values (3422)	4285	99.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10.02	1	< 0.1%
10.03	2	< 0.1%
10.07	1	< 0.1%
10.09	1	< 0.1%
10.1	1	< 0.1%
10.11	1	< 0.1%
10.17	1	< 0.1%
10.19	1	< 0.1%
10.21	2	< 0.1%
10.25	1	< 0.1%

Value	Count	Frequency (%)
99.99	1	< 0.1%
99.97	1	< 0.1%
99.96	1	< 0.1%
99.93	1	< 0.1%
99.92	2	< 0.1%
99.88	2	< 0.1%
99.87	1	< 0.1%
99.86	1	< 0.1%
99.85	2	< 0.1%
99.83	2	< 0.1%

Reorder Quantity (liters/kg)
Real number (ℝ)

Distinct	3833
Distinct (%)	88.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	109.10782

Minimum	20.02
Maximum	199.95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	20.02
5-th percentile	28.99
Q1	64.28
median	108.34
Q3	153.39
95-th percentile	189.812
Maximum	199.95
Range	179.93
Interquartile range (IQR)	89.11

Descriptive statistics

Standard deviation	51.501035
Coefficient of variation (CV)	0.47201965
Kurtosis	-1.1766584
Mean	109.10782
Median Absolute Deviation (MAD)	44.44
Skewness	0.013757116
Sum	471891.32
Variance	2652.3566
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20.41	4	0.1%
157.81	4	0.1%
126.54	3	0.1%
173.77	3	0.1%
119.65	3	0.1%
191.7	3	0.1%
66.62	3	0.1%
26.59	3	0.1%
36.73	3	0.1%
167.14	3	0.1%
Other values (3823)	4293	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20.02	1	< 0.1%
20.04	2	< 0.1%
20.09	1	< 0.1%
20.12	2	< 0.1%
20.14	1	< 0.1%
20.15	1	< 0.1%
20.18	1	< 0.1%
20.19	1	< 0.1%
20.21	2	< 0.1%
20.23	1	< 0.1%

Value	Count	Frequency (%)
199.95	1	< 0.1%
199.92	1	< 0.1%
199.81	1	< 0.1%
199.77	1	< 0.1%
199.71	2	< 0.1%
199.68	1	< 0.1%
199.59	1	< 0.1%
199.47	1	< 0.1%
199.45	1	< 0.1%
199.43	1	< 0.1%

Auto

Heatmap
Table

	Total Land Area (acres)	Number of Cows	Product ID	Quantity (liters/kg)	Price per Unit	Total Value	Shelf Life (days)	Quantity Sold (liters/kg)	Price per Unit (sold)	Approx. Total Revenue(INR)	Quantity in Stock (liters/kg)	Minimum Stock Threshold (liters/kg)	Reorder Quantity (liters/kg)	Location	Farm Size	Product Name	Brand	Storage Condition	Customer Location	Sales Channel
Total Land Area (acres)	1.000	-0.010	-0.008	-0.001	0.017	0.007	0.006	-0.038	0.014	-0.024	0.024	0.011	0.014	0.000	0.026	0.000	0.000	0.000	0.000	0.016
Number of Cows	-0.010	1.000	0.010	-0.004	-0.006	-0.014	0.001	0.009	-0.007	0.004	-0.021	0.003	0.029	0.000	0.000	0.018	0.019	0.000	0.013	0.041
Product ID	-0.008	0.010	1.000	-0.028	0.003	-0.013	-0.112	-0.023	0.001	-0.020	-0.015	-0.005	-0.003	0.000	0.012	1.000	0.435	0.800	0.018	0.029
Quantity (liters/kg)	-0.001	-0.004	-0.028	1.000	-0.010	0.762	-0.004	0.654	-0.008	0.568	0.684	-0.010	0.003	0.018	0.000	0.017	0.026	0.000	0.000	0.015
Price per Unit	0.017	-0.006	0.003	-0.010	1.000	0.569	-0.006	0.001	0.994	0.427	-0.011	0.012	0.008	0.017	0.000	0.000	0.000	0.010	0.022	0.022
Total Value	0.007	-0.014	-0.013	0.762	0.569	1.000	-0.005	0.533	0.567	0.749	0.547	0.010	-0.000	0.006	0.019	0.009	0.009	0.000	0.000	0.031
Shelf Life (days)	0.006	0.001	-0.112	-0.004	-0.006	-0.005	1.000	0.011	-0.006	0.004	-0.004	-0.012	-0.027	0.011	0.024	0.524	0.313	0.562	0.017	0.000
Quantity Sold (liters/kg)	-0.038	0.009	-0.023	0.654	0.001	0.533	0.011	1.000	0.001	0.876	0.024	-0.003	0.008	0.000	0.000	0.009	0.000	0.019	0.016	0.000
Price per Unit (sold)	0.014	-0.007	0.001	-0.008	0.994	0.567	-0.006	0.001	1.000	0.430	-0.011	0.014	0.005	0.000	0.011	0.008	0.000	0.000	0.020	0.000
Approx. Total Revenue(INR)	-0.024	0.004	-0.020	0.568	0.427	0.749	0.004	0.876	0.430	1.000	0.038	0.007	0.003	0.025	0.000	0.000	0.005	0.000	0.012	0.030
Quantity in Stock (liters/kg)	0.024	-0.021	-0.015	0.684	-0.011	0.547	-0.004	0.024	-0.011	0.038	1.000	-0.002	0.013	0.000	0.032	0.022	0.000	0.000	0.000	0.000
Minimum Stock Threshold (liters/kg)	0.011	0.003	-0.005	-0.010	0.012	0.010	-0.012	-0.003	0.014	0.007	-0.002	1.000	0.017	0.000	0.000	0.000	0.000	0.000	0.010	0.000
Reorder Quantity (liters/kg)	0.014	0.029	-0.003	0.003	0.008	-0.000	-0.027	0.008	0.005	0.003	0.013	0.017	1.000	0.019	0.024	0.013	0.000	0.028	0.036	0.007
Location	0.000	0.000	0.000	0.018	0.017	0.006	0.011	0.000	0.000	0.025	0.000	0.000	0.019	1.000	0.000	0.000	0.016	0.000	0.000	0.010
Farm Size	0.026	0.000	0.012	0.000	0.000	0.019	0.024	0.000	0.011	0.000	0.032	0.000	0.024	0.000	1.000	0.012	0.026	0.009	0.015	0.017
Product Name	0.000	0.018	1.000	0.017	0.000	0.009	0.524	0.009	0.008	0.000	0.022	0.000	0.013	0.000	0.012	1.000	0.435	0.800	0.018	0.029
Brand	0.000	0.019	0.435	0.026	0.000	0.009	0.313	0.000	0.000	0.005	0.000	0.000	0.000	0.016	0.026	0.435	1.000	0.269	0.020	0.007
Storage Condition	0.000	0.000	0.800	0.000	0.010	0.000	0.562	0.019	0.000	0.000	0.000	0.000	0.028	0.000	0.009	0.800	0.269	1.000	0.000	0.000
Customer Location	0.000	0.013	0.018	0.000	0.022	0.000	0.017	0.016	0.020	0.012	0.000	0.010	0.036	0.000	0.015	0.018	0.020	0.000	1.000	0.051
Sales Channel	0.016	0.041	0.029	0.015	0.022	0.031	0.000	0.000	0.000	0.030	0.000	0.000	0.007	0.010	0.017	0.029	0.007	0.000	0.051	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Location	Total Land Area (acres)	Number of Cows	Farm Size	Date	Product ID	Product Name	Brand	Quantity (liters/kg)	Price per Unit	Total Value	Shelf Life (days)	Storage Condition	Production Date	Expiration Date	Quantity Sold (liters/kg)	Price per Unit (sold)	Approx. Total Revenue(INR)	Customer Location	Sales Channel	Quantity in Stock (liters/kg)	Minimum Stock Threshold (liters/kg)	Reorder Quantity (liters/kg)
0	Telangana	310.84	96	Medium	17/02/2022	5	Ice Cream	Dodla Dairy	222.40	85.72	19064.1280	25	Frozen	27/12/2021	21/01/2022	7	82.24	575.68	Madhya Pradesh	Wholesale	215	19.55	64.03
1	Uttar Pradesh	19.19	44	Large	01/12/2021	1	Milk	Amul	687.48	42.61	29293.5228	22	Tetra Pack	03/10/2021	25/10/2021	558	39.24	21895.92	Kerala	Wholesale	129	43.17	181.10
2	Tamil Nadu	581.69	24	Medium	28/02/2022	4	Yogurt	Dodla Dairy	503.48	36.50	18377.0200	30	Refrigerated	14/01/2022	13/02/2022	256	33.81	8655.36	Madhya Pradesh	Online	247	15.10	140.83
3	Telangana	908.00	89	Small	09/06/2019	3	Cheese	Britannia Industries	823.36	26.52	21835.5072	72	Frozen	15/05/2019	26/07/2019	601	28.92	17380.92	Rajasthan	Online	222	74.50	57.68
4	Maharashtra	861.95	21	Medium	14/12/2020	8	Buttermilk	Mother Dairy	147.77	83.85	12390.5145	11	Refrigerated	17/10/2020	28/10/2020	145	83.07	12045.15	Jharkhand	Retail	2	76.02	33.40
5	Telangana	87.64	51	Medium	07/01/2019	6	Curd	Raj	593.92	85.54	50803.9168	5	Refrigerated	03/01/2019	08/01/2019	74	84.75	6271.50	Gujarat	Retail	519	55.60	139.59
6	Karnataka	73.28	74	Small	05/08/2022	3	Cheese	Dynamix Dairies	757.14	36.83	27885.4662	83	Frozen	14/06/2022	05/09/2022	410	32.66	13390.60	Karnataka	Online	347	49.82	105.86
7	Bihar	67.61	77	Medium	14/02/2019	9	Paneer	Mother Dairy	203.36	29.08	5913.7088	14	Refrigerated	06/01/2019	20/01/2019	15	29.09	436.35	Haryana	Online	188	10.90	25.14
8	West Bengal	72.31	76	Medium	02/08/2020	6	Curd	Raj	949.12	22.79	21630.4448	6	Refrigerated	06/06/2020	12/06/2020	860	24.77	21302.20	Jharkhand	Wholesale	89	85.71	32.03
9	Telangana	413.24	36	Large	04/03/2022	8	Buttermilk	Mother Dairy	385.64	42.08	16227.7312	9	Refrigerated	03/02/2022	12/02/2022	108	46.15	4984.20	Tamil Nadu	Retail	277	93.61	66.26

	Location	Total Land Area (acres)	Number of Cows	Farm Size	Date	Product ID	Product Name	Brand	Quantity (liters/kg)	Price per Unit	Total Value	Shelf Life (days)	Storage Condition	Production Date	Expiration Date	Quantity Sold (liters/kg)	Price per Unit (sold)	Approx. Total Revenue(INR)	Customer Location	Sales Channel	Quantity in Stock (liters/kg)	Minimum Stock Threshold (liters/kg)	Reorder Quantity (liters/kg)
4315	Chandigarh	147.69	10	Large	07/02/2021	1	Milk	Sudha	513.97	34.56	17762.8032	2	Polythene Packet	17/01/2021	19/01/2021	323	32.66	10549.18	Maharashtra	Retail	190	33.84	173.39
4316	Telangana	449.88	28	Small	05/01/2021	8	Buttermilk	Amul	877.57	83.56	73329.7492	8	Refrigerated	10/11/2020	18/11/2020	855	84.48	72230.40	Gujarat	Retail	22	34.43	54.45
4317	Kerala	662.40	80	Medium	06/11/2019	8	Buttermilk	Sudha	250.96	26.81	6728.2376	14	Refrigerated	07/10/2019	21/10/2019	229	29.50	6755.50	Uttar Pradesh	Wholesale	21	30.84	39.60
4318	Madhya Pradesh	641.66	74	Small	20/01/2020	2	Butter	Warana	970.92	37.86	36759.0312	26	Frozen	13/12/2019	08/01/2020	26	42.54	1106.04	Chandigarh	Wholesale	944	36.23	32.27
4319	Uttar Pradesh	269.63	91	Small	05/03/2020	3	Cheese	Dynamix Dairies	517.69	90.28	46737.0532	85	Frozen	07/02/2020	02/05/2020	239	86.91	20771.49	Karnataka	Wholesale	278	51.96	106.10
4320	Delhi	748.71	89	Medium	24/02/2022	6	Curd	Mother Dairy	554.90	88.45	49080.9050	5	Refrigerated	16/02/2022	21/02/2022	352	87.20	30694.40	Uttar Pradesh	Online	202	98.07	33.53
4321	Jharkhand	385.91	29	Large	14/05/2022	4	Yogurt	Palle2patnam	818.33	55.35	45294.5655	23	Refrigerated	22/03/2022	14/04/2022	68	58.39	3970.52	Kerala	Retail	750	87.41	114.37
4322	Chandigarh	311.54	65	Small	05/01/2020	6	Curd	Mother Dairy	583.56	92.61	54043.4916	7	Refrigerated	04/01/2020	11/01/2020	141	89.46	12613.86	Haryana	Retail	442	33.47	153.66
4323	Maharashtra	890.55	90	Small	25/10/2022	6	Curd	Raj	3.10	15.30	47.4300	7	Refrigerated	02/10/2022	09/10/2022	2	10.56	21.12	Jharkhand	Wholesale	1	58.25	160.84
4324	Rajasthan	492.86	58	Large	20/01/2019	1	Milk	Mother Dairy	820.50	49.31	40458.8550	1	Polythene Packet	06/01/2019	07/01/2019	417	44.55	18577.35	Madhya Pradesh	Online	403	22.34	189.63

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters